SD-Venkat-2016-03-01 - 25841-Spec- Product Catalog updates (Filip by 2016-04-22) #ABAPEXTRACT
SPECIFICATIONS
25841-Spec-Product Catalog Updates
Purpose
Product Catalog Updates
Admin Info
Purpose
|
Product Catalog Updates
|
Requested By
|
Filip
|
Spec Created By
|
Venkat
|
Spec Created Date
|
03/01/2016
|
Spec QA by
|
Venkat
|
Objects
|
ZISD_EXT_PRODUCT_CATALOG,
ZISD_EXT_PRODUCT_CAT_CHANGE,
ZPRDCAT_LOG
|
Document Status
|
Complete
|
Estimates
Sl.No
|
Activity
|
Estimation in Hours
|
1
|
Research
|
|
2
|
Documentation
|
04
|
3
|
Development/ Config
|
60
|
4
|
Unit test in DEV
|
20
|
5
|
Unit test in QUA
|
|
6
|
Other activity
|
|
|
TOTAL
|
84
|
References
Prior Tickets
[Provide links of prior associated Spec / Break Fix BOSS document(s)]
Documents
[Attach any document(s) received for the requirement(s)]
Spec Changes
[List the changes made to program after the approval of the original requirement along with the Date on which the change request was received and the name of the initiator]
Sl.
|
Change Details
|
Requested By
|
Requested On
|
Notes if any
|
1)
|
Add new selection field Record Count and Split the files based on the record count
|
Filip
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Functional Requirement
Purpose/WHY:
[Explain the purpose of the project and the reason why this requirement has come]
New changes to the product catalog extract are needed.
1) We need to add this logic to the extract:
a. If Season = RES, then ORDER_DATE_FROM = Current Date ( Program Run Date )
ORDER_DATE_TO = Current Date + 1
2) When we run the daily UPDATE job to check changes, this should allow "GOOD" materials to process and only fail the ones that error. The problem here is if we run an update for 4000 materials with varying seasons/collections and one material fails... there is visibility for the users to "good" materials
3) We need to add the following data and columns to the error table ZPRDCAT_LOG
- PHLVL1
- PHLVL1 DESC
- PHLVL2
- PHLVL2 DESC
...
- PHLVL8
- PHLVL8 DESC
- NRF COLOR
- NRF COLOR DESC
- PMS COLOR
- PMS COLOR DESC
- FCC
- FCC DESC
4) Add Record Count in Selection Criteria and split the output file if the number of records records exceeds the record count. File number should be added to the file name.
In Scope:
[List the
activities to be included in scope]
Out of Scope:
[Out of scope activities]
Solution Summary
[Discuss this section with Requester and get approval prior to beginning work]
The following changes are required.
1) Change Season ORDER_DATE_FROM and ORDER_DATE_TO when season is 'RES'
2) When we run the daily UPDATE job to check changes, this should allow "GOOD" materials to process and only fail the ones that error. The problem here is if we run an update for 4000 materials with varying seasons/collections and one material fails... there is visibility for the users to "good" materials
3) We need to add the following data and columns to the error table ZPRDCAT_LOG
- PHLVL1
- PHLVL1 DESC
- PHLVL2
- PHLVL2 DESC
...
- PHLVL8
- PHLVL8 DESC
- NRF COLOR
- NRF COLOR DESC
- PMS COLOR
- PMS COLOR DESC
- FCC
- FCC DESC
4) Add Record Count in Selection Criteria and split the output file if the number of records records exceeds the record count. File number should be added to the file name.
- Requirements 1),3) and 4) should are applicable to programs ZISD_EXT_PRODUCT_CATALOG and ZISD_EXT_PRODUCT_CAT_CHANGE
- Requirement 2) should be carried out in program ZISD_EXT_PRODUCT_CAT_CHANGE
Test Plan
[List test scenarios/cases to be executed here]
Test ID
|
Test Scenario
|
Expected Results
|
SD001
|
|
|
SD002
|
|
|
Solution Details
[Provide complete technical details for configuration or programming here]
- Added new fields in Product Catalog table (ZPRDCAT_LOG)
- Modified program ZISD_EXT_PRODUCT_CAT_CHANGE to accommodate all the above requirement.
- Modified program ZISD_EXT_PRODUCT_CATALOG to accommodate 1), 3) and 4) requirements.
Issues
[List Issues / Bugs identified in configuration or development]